SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017576 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017576 [ RunTime:0.001899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474116,451742,333676,753638,413496,668681,633985,44206,931985,622921,740448,700514,1035614,449796,390778,216288,587185,231269,975795,775414,797304,113504,474607,287298,1046846,842317,321392,231450,135810,732956,71302,372567,173420,428049,234027,247204,361707,252509,479939,850569,104867,275658,716268,119590,894574,259086,285123,50443,1022604,495508,736676,448402,301383,874933,589582,452089,986627,901520,658870,981428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017576 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017576 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]