SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 809112 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 809112 [ RunTime:0.001729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18609,1025932,36427,408200,1004469,59123,525868,265927,398211,159409,139964,405364,774573,296634,827986,54199,561006,645945,712119,542308,588698,286111,668569,428333,181589,1007864,197943,721929,345029,364470,783552,95305,717557,789847,696965,575407,916635,201141,489308,1038589,165273,707134,297304,220127,745742,958700,523351,747184,141311,983526,675508,721500,1041428,535522,425769,210737,273182,191011,797571,937089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 809112 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 809112 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]