SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001968s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425442 LIMIT 1 [ RunTime:0.000789s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425442 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (75895,248659,218983,74268,540469,769230,853930,421451,961842,327489,985984,800620,210418,273527,568592,275793,836198,710774,1015730,670949,799976,663574,734099,139288,918140,130740,461164,426163,490152,266479,372668,342781,858081,340190,242345,686960,71176,363151,442354,61112,776165,749121,29833,612730,638551,437927,855941,601892,518087,368797,888350,194093,403456,349813,247402,581067,431955,104476,153024,580051) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425442 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000585s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425442 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]