SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039571 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039571 [ RunTime:0.002047s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (214960,389609,628874,890491,914875,458185,298535,886982,533995,902238,131852,582075,103705,484035,589644,479582,375826,502502,413971,310377,415041,169417,540986,187687,132381,666932,1017758,430986,873259,882322,495936,224561,583072,301442,15403,224566,226475,1042333,746380,748325,531892,165706,127626,71762,976724,708785,565779,1041779,514364,1015495,934140,32024,377416,128334,448279,878225,179542,175991,613096,969317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]