SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001422s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 874403 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 874403 [ RunTime:0.001832s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (700811,441781,147615,944697,121996,272171,610783,824225,817738,97360,584385,356,506197,181229,98708,31956,32507,487360,718216,745874,969474,220065,154816,424428,233720,225467,567653,54325,264854,456219,287712,434284,947568,837120,1030027,399462,498198,869751,946985,855337,840755,429769,653518,570915,29031,473029,373178,140404,870210,119110,252995,347144,1033239,902590,26272,140184,447186,976181,343981,833263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 874403 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 874403 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]