SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001930s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020132 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020132 [ RunTime:0.003646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (278409,1044318,811984,56333,71503,252510,603766,493907,250436,724449,346610,982102,313067,683235,37725,220001,924952,783568,197993,195288,487985,821572,445206,574060,469716,603944,437424,883573,907174,685926,999496,216013,379105,221117,490701,1030784,623359,840462,523729,341539,1037648,384202,593035,332074,612436,85787,717503,677019,288438,590973,309976,437425,1019718,531107,745374,345448,250260,217253,212953,284303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020132 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000703s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020132 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]