SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310593 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310593 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284661,292453,435855,668785,962015,890283,494247,1004817,820718,967335,782192,523636,197406,927114,295184,884251,909611,583042,454967,261967,495846,376786,867415,438483,80817,109304,499898,400186,319463,825797,864056,942895,116591,497928,502421,390515,721271,978801,784308,572766,1044542,147148,482026,287246,135197,474776,484668,119433,12769,454376,943869,778547,550464,373185,354469,498031,978459,304318,108306,462856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310593 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000590s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310593 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002066s ]