SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 266276 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 266276 [ RunTime:0.001656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602068,567764,193844,908715,109369,589217,629917,897014,836153,446503,999951,722635,664554,408224,15710,268994,696438,1000435,204954,824541,701760,133305,141837,1042824,341665,864578,916561,47237,408629,615899,337374,577536,710517,737343,898947,349687,531830,910733,433395,760381,19713,172879,704636,934136,855403,321161,541447,611089,984513,1037899,518054,75827,611385,341552,382927,1031580,283686,649410,596104,914275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 266276 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 266276 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]