SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401370 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401370 [ RunTime:0.001585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398319,495005,839572,608528,529049,684203,671724,72877,597493,926960,21193,983204,63601,828878,301413,778593,567011,698110,472140,319193,1033072,187577,624090,538058,372144,1022176,732943,936404,521370,648276,792909,628046,485936,251591,476888,373698,847177,60857,104893,309575,635522,575289,279045,653121,221711,1009007,517233,242424,688177,692477,912344,288590,145282,227180,996851,844066,237967,574053,1027472,186375) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401370 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401370 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]