SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41916 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41916 [ RunTime:0.001766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391442,225747,351126,265430,930639,152956,196090,925382,1001250,202224,82227,308734,1002227,331989,668373,566140,195491,864202,399222,230276,141989,1028992,119752,896709,626944,326581,120920,671906,742013,186348,846887,1021562,57488,4791,318320,813919,747490,998856,176734,536922,656110,972793,353386,381132,322181,313396,987235,400167,294185,141968,661288,574676,737427,415014,614465,672589,175682,837261,944043,93676) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001281s ]