SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403269 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403269 [ RunTime:0.002749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (609509,402155,351376,411348,132812,274746,405825,661719,130395,238009,863714,527011,600245,73469,328625,954944,577058,902215,577947,123718,69598,206941,320850,951194,144015,384485,238685,183384,998649,326295,975375,549707,1035432,618255,578225,948405,981286,331621,81065,1000201,185782,959007,586506,7203,264834,536015,700117,970169,802089,359922,691745,495091,536352,445903,603826,101429,587245,385791,865588,81425) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001643s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403269 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403269 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000815s ]