SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410706 LIMIT 1 [ RunTime:0.000476s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410706 [ RunTime:0.002174s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447706,184481,619088,977909,404040,52698,229675,598884,306483,21243,875550,920986,418488,418677,742145,165833,248043,271617,722113,170165,430616,606095,895612,709646,139609,635453,220335,462207,978916,966794,117395,786423,755551,355288,499124,453877,29358,634162,268248,707865,208727,749808,251614,31732,921506,11714,346995,977953,730521,192911,203702,928070,446134,719446,549992,735754,94828,677706,177650,692319) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410706 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410706 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001441s ]