SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510862 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510862 [ RunTime:0.003136s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (344083,425267,323681,253943,561790,541621,295152,678120,790920,742686,875250,886485,851246,193836,702478,1037175,880327,344070,263105,884071,1038632,577888,169749,947862,386366,47626,1031400,689953,960368,324769,273553,67432,333614,658933,324899,291383,225480,327828,842710,260095,261035,362412,763038,79905,412019,519700,1030577,259006,241418,454280,50867,547684,946370,45136,69697,694438,385696,992257,237058,873092) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510862 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510862 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]