SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501468 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501468 [ RunTime:0.001465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (350636,1013854,953825,767285,907541,288260,669529,543221,290598,236083,43518,29588,504522,56831,525345,15582,154623,139311,949895,746109,689370,404017,358729,606689,884202,284946,84313,646251,706219,541189,206700,862490,310977,637186,235368,749696,93630,926809,455244,539972,836370,50252,670564,948007,136554,613819,229390,114657,226140,89442,272554,396452,345038,115296,24288,217785,899392,528181,549612,20332) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.018458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501468 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501468 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001743s ]