SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438829 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438829 [ RunTime:0.001797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (479496,763045,564377,1000866,307363,385168,81541,110044,817556,40044,397187,863950,199109,367332,248998,373926,130289,850768,866652,781112,341519,236904,201308,569111,252495,610298,181878,955891,338244,794938,163407,638667,124557,683891,1032645,511368,40232,629704,777599,316634,284363,417268,613269,385985,35176,30340,852966,1012986,385011,743906,132898,817460,451728,478444,552014,172061,481405,596318,677605,912351) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438829 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438829 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]