SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001384s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 599540 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 599540 [ RunTime:0.001741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (730030,927499,411092,236021,712209,383057,848727,1016461,371357,941660,349916,165334,511659,773150,1030700,719364,728769,729586,903807,181589,492053,1024124,229304,1042481,432703,142157,600424,466372,11565,1002559,174367,345758,746179,580049,209240,479903,691510,191692,537691,984121,388465,447344,932826,305215,120348,678098,183864,4968,377560,858065,871220,606162,671537,494540,743162,806501,320144,875086,921156,345535) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 599540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 599540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001829s ]