SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011197 LIMIT 1 [ RunTime:0.001469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011197 [ RunTime:0.002480s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (260277,389287,30562,333496,65891,804105,115078,864371,49285,315650,996557,806872,652319,563057,213079,104874,408072,981228,246734,706721,303606,335474,522149,895717,863088,1046175,8194,806512,634922,910971,282777,971229,762048,336449,47504,780527,137234,20142,189574,375385,67238,63338,614815,562537,1042826,258194,162533,941213,515009,795853,286818,735125,743323,550219,975101,364794,980835,894016,1539,317857) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011197 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011197 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000751s ]