SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 592089 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 592089 [ RunTime:0.001951s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (220506,950871,353414,612890,1024783,651698,562303,814653,896778,1010904,1027836,271199,213512,809937,818593,846407,257446,440428,510896,352779,379057,574127,131447,256940,708309,663841,802338,1033939,836778,737699,541289,542460,685701,844093,538473,880669,314422,43437,134903,916958,579300,217379,1003800,118868,496333,445009,385500,410013,297858,641482,779355,855583,1026910,978765,10892,70488,994370,556223,332642,338630) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 592089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 592089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]