SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001588s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506612 LIMIT 1 [ RunTime:0.000484s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506612 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (808317,126487,699872,576586,279329,967684,451009,362834,665086,89478,549652,972862,1023375,824223,232655,577660,664441,514569,81928,228113,110753,429087,53165,71184,504313,324678,366483,459115,231481,646674,83980,1038545,332072,710193,341535,895884,644144,871534,945321,770952,388877,498964,420136,214261,246056,468875,786653,603089,40127,685680,711678,672256,801410,904617,992498,72469,410641,595824,443449,35795) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002941s ]