SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013270 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013270 [ RunTime:0.003443s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (754371,435559,483415,575542,543452,338095,413481,254060,149682,739698,558790,969073,692959,107577,834903,254102,885062,349492,497169,507585,471853,1007305,620125,23570,377711,901240,438179,710789,726916,593007,130456,487400,807610,770716,283065,518352,981660,92637,198859,720652,381233,318182,277946,329394,52238,1002871,824176,887032,530287,398920,52358,1048177,463058,927680,1004992,253345,270668,370222,869141,539449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013270 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013270 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001365s ]