SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003515s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416233 LIMIT 1 [ RunTime:0.003666s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416233 [ RunTime:0.003263s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (563851,281893,436783,161374,957984,928220,185262,132112,260392,1009321,258849,420246,98493,571054,721850,433099,887870,32383,185689,1044697,506953,1034665,409059,783276,121966,885953,39462,974295,324993,160556,282017,670166,28958,376467,802686,1047719,178355,925121,656843,930165,991749,1040094,401624,458976,189335,869074,801893,310059,819632,763135,499003,9288,918801,30166,401565,412415,191698,480259,299077,625170) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416233 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000754s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416233 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000982s ]