SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020282 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020282 [ RunTime:0.001675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (879563,408665,186271,832950,28427,168054,498574,114388,8524,263377,152326,304148,730443,666913,26761,516850,314701,363594,708706,884223,148915,13707,1026716,75511,74952,285536,995251,895436,706571,1028036,815117,334362,875841,91090,696989,353479,748114,412797,861661,970733,348957,357233,185877,915601,254845,34160,35463,261557,233034,243090,920699,977550,770638,54841,992238,596331,342010,747748,1041118,983730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003853s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020282 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020282 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001590s ]