SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596604 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596604 [ RunTime:0.001854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (841116,88468,723167,570101,80988,279085,185458,907577,705467,103549,248907,21110,352996,784719,143697,143948,347480,869849,41380,714754,252964,130378,226356,261266,18158,88920,362873,464473,297404,689230,880146,616049,765794,412250,979962,947444,214752,814487,981206,977200,1025362,1071,996679,620954,696729,863778,562498,381330,964103,84713,336208,727058,126137,239588,301109,174030,554028,510157,773437,582925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596604 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596604 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]