SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003915s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 364311 LIMIT 1 [ RunTime:0.000727s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 364311 [ RunTime:0.002438s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539224,245913,785331,428858,837716,412053,947398,232231,312080,35902,74121,608451,1008976,957879,33965,30064,358673,940014,471502,564489,1003995,39640,242719,170680,206814,733748,116316,859537,487453,1003835,797884,762284,957228,496721,786508,419302,835058,190902,256705,988940,650188,714588,742813,399375,759117,243557,1009037,208393,929889,562614,38050,646662,527980,792441,505577,414758,406451,8054,239258,988842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 364311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 364311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]