SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 36103 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 36103 [ RunTime:0.002162s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (467545,553014,61180,852098,75213,619439,536990,83604,417401,1032202,418014,447492,625402,825332,335309,989941,304857,950468,62732,398228,851885,316939,351661,129958,662049,241559,972774,541905,222848,432786,790192,243267,269751,644826,193336,191146,624832,810119,789643,679938,771214,757618,678536,1046383,3815,818506,228497,133991,917781,507957,135527,663356,472873,521544,709860,211015,2923,611785,454305,576138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 36103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 36103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]