SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44869 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44869 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410011,751428,315978,900472,892337,750796,294858,655778,865399,59384,954097,768531,550089,185943,35454,387109,707492,332843,44567,121433,552380,1021402,491071,38452,844680,1006272,658777,291988,519770,111120,699,91075,846348,374135,944115,407473,279164,409284,1029299,926326,832583,650230,576157,28624,407495,199515,415078,879070,614031,465569,130393,347122,359917,282219,327275,885621,100623,762114,179834,80119) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44869 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44869 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000949s ]