SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491711 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491711 [ RunTime:0.002496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (335813,911024,860919,999597,355362,951378,284532,749693,699516,498721,380080,813565,561104,62035,65446,306608,443030,541224,244230,363906,226942,37683,475445,24786,351504,898285,352058,7033,347786,552546,592304,467633,557505,627860,353927,622516,721917,1046706,832885,710201,531858,572797,145354,42021,183420,620665,718568,92053,645119,842314,1006368,106688,620226,804385,294637,876359,1004568,384054,397411,201527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000903s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]