SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806913 LIMIT 1 [ RunTime:0.000568s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806913 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529816,996426,558043,407359,1021195,416405,966569,584931,990619,179847,493973,856346,181504,306345,362591,679893,280735,968477,403439,694159,966348,73521,392160,724916,331768,479666,751370,969838,990354,528975,120599,216264,687246,621511,347552,740884,669727,179680,9271,709968,287665,842674,179846,816370,721430,748539,504916,102839,285738,897798,850854,792960,406615,556666,163780,898442,29335,817393,17098,538651) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]