SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 398257 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 398257 [ RunTime:0.001556s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282780,394770,605197,467387,983874,914421,704521,1023464,398468,113963,908997,962203,176879,787285,343402,425000,799387,201509,951740,354169,414018,290898,248696,679611,469302,891981,938523,714740,701868,627977,714217,265639,391572,557930,663547,170883,677193,532989,305796,75086,417867,546536,41449,696198,360008,728005,657444,6540,578526,455463,831081,951020,397575,768638,888456,960234,604125,995680,323196,4065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002901s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 398257 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 398257 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001558s ]