SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433138 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433138 [ RunTime:0.003273s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (957320,405443,1010080,192894,976316,874909,154401,919388,273206,949176,1003777,286000,851183,551114,662460,714195,818921,490511,700144,250520,217746,108360,973019,201872,144181,392983,572067,1001704,330988,90008,821552,485576,988259,31658,216837,136025,997790,459047,9736,725713,625014,143595,517784,728438,752907,574008,1037706,716091,924157,369703,646261,642687,542301,532028,291325,966165,327877,1047027,306751,72309) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001570s ]