SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38560 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38560 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (47072,577869,130787,250573,112182,888541,87166,823860,527591,192945,373050,120422,206688,660514,58491,902929,4463,937,244045,682149,282292,853067,215940,428057,963082,843857,752906,491597,76184,599418,710579,786007,107954,1046836,387534,534557,961113,900489,883431,760371,127646,1045368,719131,1003406,628009,994506,289253,365073,741943,272551,787249,89679,492822,242401,984391,997077,900196,803003,858331,154345) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38560 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38560 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000394s ]