SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511063 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511063 [ RunTime:0.001886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (70178,1020744,137158,477727,802632,892739,469978,409667,600049,180239,422621,774877,166380,225093,959872,417205,756069,944617,204182,292993,697528,456219,46497,863983,1001920,330493,1019118,937882,98982,855985,72713,334136,809429,146020,203335,1005190,119971,25203,578805,1001676,53066,812854,260911,485440,425609,881573,838179,1021139,293747,932715,303148,1045952,515051,954892,393029,348828,195732,607612,267671,394481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001195s ]