SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001534s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42573 LIMIT 1 [ RunTime:0.000476s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42573 [ RunTime:0.001614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593330,526113,746689,253565,379843,61885,833044,111418,632890,145480,176340,769318,768645,152641,477721,357440,710716,14501,560750,478907,269181,12336,236140,589159,536645,602804,958804,840228,75244,615915,755957,402094,324651,669251,902594,773647,161402,465702,382105,370255,828288,918900,275883,126467,747859,283059,312834,136573,890581,744658,820874,970228,1023972,369781,397381,438180,640673,741201,636899,305869) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]