SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001810s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433854 LIMIT 1 [ RunTime:0.000797s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433854 [ RunTime:0.006353s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (113460,1010011,1035377,195988,147363,602790,637332,17763,15053,479539,452606,279721,533972,67261,975826,494478,825410,641856,636613,411444,192620,387549,355616,968147,220036,252735,432616,305488,558204,980744,744920,598502,975055,705688,237461,578176,5564,342136,675055,268916,910283,68161,777359,989227,1012016,329799,632057,641883,68348,994548,104704,940200,387768,766129,965948,942518,726739,295019,525119,198527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433854 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433854 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]