SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287558 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287558 [ RunTime:0.001488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407709,605572,293072,341036,248937,533684,97904,96861,336692,13083,11440,1046931,667651,720092,20985,201961,658318,115322,360715,64975,174152,824158,388849,536338,715019,257094,971844,405978,573505,797611,106687,623797,924591,268472,187106,696883,845917,451554,47343,515119,613241,671032,561720,174679,616278,34429,421412,9951,53660,123419,984134,773899,561785,377176,631622,827493,879702,525764,330200,433533) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287558 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287558 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]