SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436924 LIMIT 1 [ RunTime:0.003432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436924 [ RunTime:0.001967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (847684,826680,931127,774302,32959,391780,440714,40261,629551,662738,450080,485814,130984,310603,83687,496754,536691,157756,1004325,395993,661614,1036792,784615,712643,832951,109718,215791,814085,747779,538028,998542,507257,606932,662410,629081,904077,1013742,1034880,1025194,515618,817870,705695,334180,992639,447948,498199,246055,286538,94776,847725,647473,527559,331171,943901,296516,190770,504986,757955,414540,500299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004730s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436924 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002621s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436924 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]