SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002045s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502641 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502641 [ RunTime:0.005299s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1025793,288591,336929,661882,268372,711863,830468,865906,520060,981222,935178,992093,880519,995947,596639,158522,389458,437725,188332,314477,511055,979839,909826,863398,608952,438376,501827,459681,722484,486972,962941,892581,407559,768601,316638,574248,996267,277652,423536,897367,168680,568611,566089,444157,925071,343470,714760,896083,152694,415562,276477,421609,156812,338364,1019943,685569,361161,822820,35764,96696) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000637s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.008832s ]