SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414571 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414571 [ RunTime:0.002139s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (221412,69839,185565,875684,678386,548450,600686,352951,389384,50656,295774,222663,291180,281900,269642,249839,786076,473273,66453,184042,1022682,1023950,64877,712458,671429,651823,519169,415081,1013727,587520,717352,13281,553218,532979,587775,449032,956105,388430,658239,332010,183720,597332,39916,738850,308155,79246,262824,498653,740282,767958,950482,460426,7775,1015580,231681,244992,198236,652565,438009,477653) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]