SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537751 LIMIT 1 [ RunTime:0.000835s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537751 [ RunTime:0.001493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (897118,432727,958544,1032595,465928,778559,414135,437404,487686,695187,286894,692925,710060,268462,613683,731075,206552,665567,146607,600794,961558,256012,282129,724158,111083,867490,993310,706000,551508,816515,795853,496185,762094,33437,936972,789336,97243,68977,878042,219691,417249,121142,871635,221255,589587,382662,535465,823663,889508,1007332,861633,133366,71522,485014,821579,618507,96135,710827,81684,692559) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004620s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002158s ]