SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103489 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103489 [ RunTime:0.003887s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033339,438799,432775,543533,426628,168726,600814,584856,94462,961296,685306,5300,443681,751180,166218,228764,695224,886252,234929,568667,998632,206518,580661,486998,387702,98181,938624,961840,528605,457638,202604,457823,171359,592232,53695,815780,558733,1000087,148695,895737,191906,537415,793069,850517,670409,671355,277603,1010199,901966,435355,46454,861026,500733,286014,8016,96391,858473,340605,782679,237138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103489 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000734s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103489 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]