SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022833 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022833 [ RunTime:0.001770s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (386630,96026,304066,335390,954239,1041163,983584,830625,506586,57894,779614,556565,63931,303914,95723,433437,481157,155032,392604,671316,308604,331167,374722,778289,356691,132705,601905,375234,804848,321245,517883,433363,974227,481292,478740,269629,475845,304419,654647,53040,32155,983889,424498,901826,652190,653325,121187,748587,792609,391882,1018009,17979,101299,621565,841308,368477,97288,31074,643630,345808) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022833 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022833 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000702s ]