SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671598 LIMIT 1 [ RunTime:0.001122s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671598 [ RunTime:0.003005s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (888153,33115,129163,631466,506993,1036588,265775,175478,569123,728123,431596,1031169,316019,773504,937930,821236,274162,755362,577235,290897,332693,790057,805257,414287,745275,400857,578473,913384,338276,736498,369380,526026,523976,613344,13384,188600,809433,648901,985393,252554,702093,392449,586723,413681,951507,292671,284123,390152,237779,489752,184227,792943,836495,690082,258743,923604,483032,1710,952524,567323) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671598 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671598 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]