SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 304409 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 304409 [ RunTime:0.003017s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1012210,683791,468252,241099,167130,690583,757294,253329,68543,350555,410331,927898,250434,488268,919398,830295,622433,453285,644819,129326,153776,272903,489837,842471,310482,636535,43117,534459,653424,866384,159395,512519,380426,511506,971944,690163,932035,713740,787742,565437,238092,284576,930907,564933,32343,867610,624189,1018332,991135,779696,434126,596381,606882,291048,484875,438842,579267,668915,45222,841775) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 304409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 304409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]