SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529738 LIMIT 1 [ RunTime:0.000520s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529738 [ RunTime:0.002384s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524063,1030187,465344,79302,996444,462371,434985,956331,846682,106626,1040049,803763,175390,680359,884510,825827,666200,816874,924523,699458,200188,666199,650049,199774,114129,652975,111944,827690,234323,1010455,812971,194585,367390,908088,55794,856439,292522,586657,909438,350278,683915,908839,789316,987414,879379,206579,843055,679092,692406,693213,386878,798732,937913,249970,675216,658656,353674,850089,242524,263532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001856s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529738 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001716s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529738 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001694s ]