SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556409 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556409 [ RunTime:0.001638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (148747,442889,795088,533170,72581,858641,549500,489892,1033504,303404,850248,909671,460619,801318,666875,466255,512030,138162,341565,411916,465256,844268,1035166,617693,470467,299480,773365,796095,856939,946011,1047293,118882,331771,541961,17830,525871,331233,426455,387239,259283,714469,349569,95293,336930,427984,38016,117334,716634,25154,891978,134006,642378,19064,285894,951466,765112,338853,1014631,783503,555971) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]