SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003016s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28323 LIMIT 1 [ RunTime:0.000455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28323 [ RunTime:0.001643s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1006324,726345,558286,475455,59035,1014317,36119,22909,632761,218488,118202,338006,350214,136948,116738,309687,590445,497618,394149,920534,251178,705961,315081,316015,644812,200750,104342,817255,986239,572641,859489,36922,657321,701604,957815,34718,669764,733949,846946,818980,714313,171627,281005,751175,496248,399747,952463,389018,680657,786742,685570,61472,198231,249472,730957,453835,647397,292469,468598,668398) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002573s ]