SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001400s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038402 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038402 [ RunTime:0.001967s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (29600,608290,300054,205044,293891,552631,421345,606927,294458,430697,125368,761450,516596,863528,1021618,632161,485161,678498,502455,330178,437710,659644,248544,876269,771397,75719,440249,427627,903564,498501,13195,775010,524957,537093,224001,417404,914047,825680,295069,167627,879461,265061,236271,50281,753290,593083,22343,585529,530617,253708,349673,254201,691909,98953,993065,484165,407089,380014,487574,676950) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038402 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038402 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000774s ]