SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51562 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51562 [ RunTime:0.002747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (161018,160597,968850,229064,1009539,880425,712859,338885,863858,405526,398531,230239,178782,982683,624251,516972,513653,949683,939977,414918,992958,1046018,240446,340357,265529,50720,975380,357091,289599,746943,895805,231970,39207,652994,612716,450339,634969,994039,1025890,68470,124725,734760,775201,871075,676014,771342,20508,259459,330608,443876,1035394,397868,537987,35155,59949,353102,487953,725783,309816,80457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51562 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000835s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51562 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]