SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520414 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520414 [ RunTime:0.001539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (340531,101486,497657,320397,374900,864613,31473,113212,864462,306118,422743,326644,199441,938198,342434,849559,554051,54816,400320,1001729,735036,603624,319346,716095,396012,172130,276099,655067,564391,355776,753806,58967,589971,276471,952336,251287,875458,154261,794160,205495,113252,475166,266719,42446,102637,381507,409045,59845,963716,220154,265640,340974,312232,1002937,497018,130569,958496,889584,837005,858626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520414 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520414 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]