SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002912s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 268113 LIMIT 1 [ RunTime:0.003607s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 268113 [ RunTime:0.001626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504826,757719,960784,293079,130110,944719,1008301,626789,462016,405434,351416,661370,459739,87585,714659,1042857,493753,72579,1024608,843370,841455,455471,720600,424511,641613,283922,737143,619621,621096,721908,195088,519010,720555,74931,363631,567935,650635,862263,216067,190278,706463,138173,438436,497761,860961,944757,367214,762232,400388,870974,380823,530459,667476,336155,1015562,232449,590069,13382,832952,366996) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 268113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 268113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]