SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005680s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150504 LIMIT 1 [ RunTime:0.005950s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150504 [ RunTime:0.011865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507857,812075,418847,665855,1001399,450371,926749,939289,274321,227728,186908,984556,162632,920321,907213,587193,546181,900422,226793,350445,29123,71761,732656,632486,406440,398280,137497,157686,663355,448491,275141,156032,445309,418798,267361,997179,372363,830775,189521,735553,375818,458191,451145,545930,482093,906019,487315,817740,269373,395191,122660,400037,727988,802706,412093,775836,508142,794519,83020,407226) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002817s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003935s ]