SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025180 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025180 [ RunTime:0.003389s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194806,506710,810337,196117,285836,650002,1005902,987100,991639,35144,516584,622414,288540,761257,843721,817981,367872,565255,773598,648511,212123,20460,776880,39996,808448,1858,315257,821034,907937,920956,304442,121555,67851,20572,832077,585952,366123,375992,788901,340609,594611,80616,480312,814934,495264,957154,188493,563155,423753,391739,326350,535803,161233,562105,671324,677641,295800,1044427,841796,942189) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]