SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434213 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434213 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (894655,537708,285091,835378,704998,480970,957979,859421,363418,999931,318426,514777,184214,654806,217179,231546,555559,766426,880632,175980,421347,883661,786882,20919,560909,379637,898239,12990,584354,104134,894971,448326,827218,895098,879820,690215,1020327,1024300,975032,126737,341117,966882,371884,680624,220374,232752,1006040,250829,327638,467297,746074,76333,66123,61636,835149,1033479,151125,399815,783237,688041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005025s ]