SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502627 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502627 [ RunTime:0.001905s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42187,191669,1047010,502022,384890,265161,349551,815734,492802,307932,1016187,309878,50506,206982,798222,354206,722864,440417,287970,498281,724194,847198,842281,368747,218391,438147,545292,323517,255238,340312,755963,736804,656430,407487,748980,364190,384416,193906,969371,75930,815484,1029631,572674,362678,486482,824356,248389,812505,522739,397304,789739,704843,98849,113702,778929,829084,925949,285319,843931,38128) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502627 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502627 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]