SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101190 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101190 [ RunTime:0.002258s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (997982,422911,52787,799817,471486,1004966,762913,503233,628832,915493,370808,498117,387668,1028262,456160,785027,325837,701976,39829,514723,140083,469248,866671,1043686,282181,271602,175919,810151,696398,1021424,1013093,131376,994907,1047238,268858,706647,120445,451914,697178,49729,994498,91557,395255,610221,540549,892584,222317,184452,985937,827599,426355,867135,475065,959326,187761,206315,415092,279437,839637,795557) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]