SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804507 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804507 [ RunTime:0.001915s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407455,517271,668690,866948,133274,383420,355906,513361,634920,5733,615024,521564,715462,25702,300994,1004296,1001893,897561,415303,186919,201542,927438,953758,943328,757139,757466,30745,1014387,430305,91473,453014,812964,501503,701966,289309,910878,274279,156751,951604,959968,728392,573756,129739,291887,732701,264869,557523,699132,632594,810494,617779,46192,544575,271994,375654,732508,694111,698305,623064,376829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804507 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804507 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]