SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435846 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435846 [ RunTime:0.002976s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (252527,624958,873723,893137,510484,938126,19714,608854,666818,693428,927118,280025,811315,849224,591161,259969,336148,591225,196478,748434,701841,899424,448289,504353,979079,582496,179037,847721,440316,993213,21564,778173,718096,15501,3031,798688,618046,50268,357836,54464,84749,234663,976352,703641,63440,989995,628148,107167,792867,417928,962553,753650,545550,68243,743203,578118,645590,330557,903611,371581) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435846 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435846 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]