SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001560s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 901961 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 901961 [ RunTime:0.001986s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019938,384737,1047207,504749,244838,779484,156627,389220,233857,505118,774978,843265,45230,71056,256932,821967,298456,639981,633298,161053,1000500,664753,653430,419105,1007560,281742,937403,514503,1000023,918774,678730,367951,585504,874228,444519,107912,367120,141657,613890,66458,715988,838268,280022,77791,753679,163922,510022,330620,102204,311227,116034,939641,258988,607910,648191,667465,777923,56490,913546,919040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 901961 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 901961 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]