SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042508 LIMIT 1 [ RunTime:0.001978s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042508 [ RunTime:0.002085s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (485963,395557,346691,465443,714109,442387,948127,634453,400484,479801,1024380,926385,812081,579977,413859,322340,407936,1026212,645105,729934,455644,948408,36284,705613,296064,976137,813457,208485,848736,999252,178233,202081,591391,684203,1011894,692254,954900,349272,930920,654714,719046,1038862,569735,327473,427826,847477,951093,161604,387470,771938,482814,713963,910161,848557,813113,113422,376436,264974,691222,604430) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]