SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 353843 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 353843 [ RunTime:0.001435s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010826,567685,122007,227022,813186,516130,59894,664263,1042018,27770,187961,921802,932840,713476,693291,991028,15648,415858,1030140,266903,990235,144932,12881,592939,829779,727375,876803,73157,870562,1006786,353288,823845,313010,128399,322615,297489,148166,42137,112775,513622,65447,62470,570693,470071,260129,902246,76394,934539,241987,912931,496416,968156,568352,863441,724380,500808,896051,1025091,166916,820677) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 353843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 353843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]