SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453854 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453854 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (89007,832009,758971,532782,643364,613542,863775,897459,550071,869486,1043305,529491,105089,351900,4413,518050,698368,95470,297781,216776,41190,428263,610944,3943,907330,977966,429883,130103,195025,1332,853598,939895,220794,20412,950360,880360,432115,741229,120704,890921,968937,994908,362125,39898,461919,1035744,499008,742966,129665,195424,572635,396836,414675,403205,869274,550875,142684,1010186,582176,845942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453854 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453854 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]