SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422683 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422683 [ RunTime:0.001636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (733669,606925,401533,306335,144074,935829,997014,769107,11021,376754,403447,739681,634418,377678,738721,201948,592702,938212,181026,607841,226362,901543,378746,299562,768974,809339,323765,688588,42215,85137,481972,716778,574954,496956,310796,211024,460285,540410,939689,458146,745374,620436,522276,1021794,1029953,747085,1030952,398809,675789,1026195,957346,639170,915959,27320,781208,614236,776208,813340,673677,997783) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]