SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398120 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398120 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (365710,688380,761101,189441,291679,546332,167191,1033081,382863,962567,254224,356033,325788,831362,914005,509797,782099,124427,343759,788950,93829,55263,163007,790379,15426,474294,229035,349749,822257,827911,603145,842036,215322,1033009,500368,584812,218490,332049,73011,101842,918110,218656,532734,209631,745742,185610,777130,891624,859786,974684,200302,938544,973783,1047851,274566,1021143,97180,154565,47131,665994) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398120 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398120 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]