SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284038 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284038 [ RunTime:0.001716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (221243,400841,591662,485516,844563,776801,229742,1002966,257798,520069,342150,53161,488953,948791,150377,931488,124331,473647,302351,850399,111666,535073,95634,293273,209555,145168,658724,229097,381495,67422,257597,323338,447903,524299,363614,12908,572308,841199,523629,433177,568954,668689,539929,829164,616082,59468,210393,117957,227223,383024,669682,177185,617035,653359,117456,110833,41137,670131,529898,277812) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]