SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405509 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405509 [ RunTime:0.002469s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (366070,189365,762887,913253,661664,987573,572320,1048137,274769,228011,514217,527827,103573,630116,885827,522545,102004,891875,1000805,139890,899816,152600,302492,557054,103805,306244,904776,194924,430735,866279,515042,730470,335649,755720,909194,165000,681243,884008,670723,837494,316778,453901,46022,811013,986511,336246,361775,369770,778206,49837,1682,640183,223593,215814,818478,575865,335908,673503,760900,179338) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]