SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001687s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413628 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413628 [ RunTime:0.003157s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (611817,968984,232340,368976,658871,152715,624346,885026,867288,575868,99579,750847,993288,905123,448586,162663,708254,704004,446124,192619,336155,739213,818825,63951,646674,73212,875100,905025,870167,244511,488970,581928,465918,100081,138548,777583,662439,45394,868674,41139,946977,101938,687496,311105,635059,700754,654262,848522,76726,639909,448837,630161,992638,958408,656434,619209,71190,184964,681487,824801) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]