SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422312 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422312 [ RunTime:0.001453s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (259670,764869,201510,432063,473106,343237,1031741,962779,758365,462786,120100,201960,23143,471685,454100,802507,257652,288135,121905,1008529,532748,481106,499529,671606,113811,839508,369911,113943,10065,850346,480535,616235,279922,190306,4747,263078,119369,449326,58138,640679,35193,731284,911298,314287,235779,745827,360931,950082,279711,798894,1062,364493,262832,664625,785526,748745,965210,999736,46003,248027) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000433s ]