SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505841 LIMIT 1 [ RunTime:0.000284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505841 [ RunTime:0.001851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (359775,810676,878567,652713,561922,64450,623117,149883,983864,365879,523493,156025,1014825,934921,412962,852660,785894,95754,658514,535360,905497,537340,47667,509817,103665,405178,89323,574574,736070,814071,512209,744480,11447,726974,267748,766832,809408,327057,794151,456319,245700,601651,205120,484652,832209,686769,502318,927775,603931,1001411,237042,756723,286491,202047,620633,105148,804944,362697,393945,991711) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009633s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000410s ]