SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001638s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006048 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006048 [ RunTime:0.003428s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (725564,136259,430213,595494,982732,1036107,500605,205747,737882,242762,968292,871835,263665,339954,252323,155850,275928,126926,290489,158267,612561,1007807,643017,431330,879887,827199,589675,561391,398571,1029516,190176,128704,597505,565439,121868,549921,585333,488612,309486,636849,167482,510405,828019,102075,780089,774579,815606,694700,678082,592574,1015600,781900,366249,108583,962046,393113,599360,841439,502211,343641) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]