SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001655s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 315311 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 315311 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (278641,526830,85144,127501,380087,540613,987787,775453,231890,155252,437921,759189,287590,114409,905127,553583,185402,482132,719633,1022284,154971,697048,651509,711436,589531,137603,1025998,33908,766335,337924,480766,650421,954169,46336,210293,395973,798675,248998,720972,611742,142653,794931,472904,122348,681892,685109,520411,493429,719447,1006745,751321,475483,600812,858173,158261,437668,130043,835884,6805,251396) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 315311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 315311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]