SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 397518 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 397518 [ RunTime:0.002559s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (978873,509081,742949,697751,899947,273534,852286,241447,864082,155639,38849,411914,477068,801043,736973,55989,959664,821654,857632,424876,572032,894563,940178,265191,510155,491712,141224,868379,874721,646729,995768,373110,319800,383342,647688,227770,834531,960402,386766,574866,623782,927927,237153,1000882,495788,974202,423792,372755,1039086,195846,277457,1038739,333754,815645,909952,144508,262632,504908,69225,1031679) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 397518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 397518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]