SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002525s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405557 LIMIT 1 [ RunTime:0.000958s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405557 [ RunTime:0.002012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (907129,383562,431508,352124,1037410,617746,228558,1036526,57124,424955,1021831,105382,966567,157888,142293,707925,318950,578606,268181,742380,641086,946476,970683,868971,1019776,553260,134716,384295,894313,476293,167210,321063,848076,873659,438070,979758,691913,824578,699608,257551,1022584,286092,4566,927337,826544,471766,962108,193253,719491,527209,736587,128054,1044394,899652,167248,896470,1027105,478380,474919,548144) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405557 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405557 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]