SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475501 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475501 [ RunTime:0.001523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (468697,765566,540181,446415,548984,342524,483749,338237,465685,870889,749313,111735,346390,384108,137909,44094,605539,398538,298395,465338,409400,804634,949099,617642,817185,345460,704400,112107,956403,952604,297639,582630,853725,738354,276840,408692,496797,878247,888767,318837,1003937,1044410,589181,31137,534685,565040,248466,608636,594951,395276,1042439,580145,886496,551821,464785,326550,945017,197620,1001015,834416) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000357s ]