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` = 593993 LIMIT 1 [ RunTime:0.001802s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 593993 [ RunTime:0.003841s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (212091,416969,81772,670168,864093,992300,151724,288687,767065,690792,15672,923075,199108,226250,402378,999836,939569,859701,604832,438518,724348,595342,954942,137426,710174,225505,540169,950456,844802,836774,450096,687346,15343,477722,852298,144428,217600,496497,520293,491528,1017341,505975,224021,919938,1001346,255324,921124,593898,307495,211530,74639,284974,149979,721297,227344,62074,509938,802339,200590,722754) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 593993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 593993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002258s ]