SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 437718 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 437718 [ RunTime:0.001979s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (451667,547777,343424,416998,979884,682141,202393,319929,785166,248847,804738,212474,992368,878848,667104,133419,514999,982248,267914,467260,785100,995333,78863,92066,593114,284372,971367,195598,959404,193679,519798,397791,202655,412977,546321,827144,50478,38700,665726,643546,304488,94168,119462,33299,22132,716846,562052,91622,803037,269450,214970,192290,252754,701415,802539,936758,83742,813932,815072,244037) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 437718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 437718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]