SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529438 LIMIT 1 [ RunTime:0.000286s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529438 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (81783,59208,157806,811199,845693,705416,796075,498355,283559,375555,32939,1047003,750999,675092,591155,200148,281784,676088,867122,809836,654725,528598,428313,839643,985829,988262,486080,650118,233408,496296,244337,377529,920666,1006474,605449,119115,706378,935381,224458,39294,453790,144370,873533,147382,278744,107238,1013990,553570,830841,909142,10374,988167,441218,616269,785827,712680,542634,518203,404430,220479) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]