SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001718s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 907540 LIMIT 1 [ RunTime:0.001094s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 907540 [ RunTime:0.001890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (211358,806586,43687,498544,38045,476575,308190,1002685,807078,448368,383601,109295,461484,670121,237614,76474,860679,650287,881446,389565,20674,901363,351937,311098,686140,137920,459003,762715,585763,536594,368397,535418,150131,687167,144781,574855,63589,60549,592688,278589,711571,982754,940083,82347,589687,975375,465026,939206,395767,342929,731794,66895,578556,687516,266156,705656,970064,622423,536719,788228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 907540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000577s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 907540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000667s ]