SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487336 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487336 [ RunTime:0.001687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (650031,704897,686612,1022049,275950,802813,744017,251380,333275,304291,669514,725364,157659,881401,78524,223028,337553,894,989745,458706,390515,160252,1008168,857839,496445,228414,213468,292572,30929,322604,692475,928498,791565,693013,179765,799806,140568,266079,271675,618191,396169,88085,717385,841432,372964,350693,892392,559101,129486,172837,928652,902077,345322,194913,383409,50606,755993,10709,846264,432927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487336 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487336 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]