SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510023 LIMIT 1 [ RunTime:0.002094s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510023 [ RunTime:0.002459s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (743120,150782,201456,942754,330602,193296,288607,433628,389619,431071,736984,497069,390648,643211,700842,262017,857520,564654,112779,440385,454343,450316,396643,748696,890432,1019067,92142,795212,845796,684026,533953,117929,956682,1040345,565682,430846,109957,1016799,69956,518223,612668,839005,693970,315443,88187,989004,157137,743067,40445,719852,977691,999726,469318,386910,296166,821485,572055,298009,589506,555353) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]