SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488793 LIMIT 1 [ RunTime:0.003361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488793 [ RunTime:0.002483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (449330,903507,701387,341742,1036971,317028,432143,678710,312353,871551,173483,531066,332118,837458,429604,881033,1010042,321949,204066,160886,263565,938936,288583,131440,960971,475751,775123,985530,609991,178481,201582,10797,1036150,20100,79464,638407,161250,904168,544470,211029,365732,543041,411610,571777,241279,732284,159971,790830,180014,688863,465982,146707,279148,624938,159174,991311,227716,944364,962660,366716) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007707s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488793 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488793 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]